package vivek.project.pocketmoney.loans
{
	import flash.data.*;
	import flash.errors.*;

	public class LoanSQLScript
	{
		public static const ADD_NEW_LOANTRANSACTION:String="INSERT INTO loantransaction (lt_loanid,lt_txntype,lt_account,lt_date,lt_amount,lt_expenseid,lt_instru,lt_deposittype,lt_userid,lt_rate)" + "VALUES (:lt_loanid,:lt_txntype,:lt_account,:lt_date,:lt_amount,:lt_expenseid,:lt_instru,:lt_deposittype,:USERID,:lt_rate)";
		public static const LOAN_GET_DATA_ALL:String="SELECT * FROM loanmanager";
		public static const LOAN_GET_ALL_TRANSACTIONS:String="SELECT * FROM loantransaction order by lt_account,lt_date asc";
		public static const ADD_NEW_ACCOUNT:String="insert into loanmanager (lm_loandesc,lm_bank,lm_principal,lm_rate,lm_period,lm_userid,lm_emi) values (:lm_loandesc,:lm_bank,:lm_principal,:lm_rate,:lm_period,:USERID,:lm_emi)";
	}
}